| Column | Data Type | Nullable | Default | Description |
| ORDER_ID | NUMBER(12, 0) | not null | | PRIMARY KEY column. |
| ORDER_DATE | TIMESTAMP(6) WITH LOCAL TIME ZONE | not null | | TIMESTAMP WITH LOCAL TIME ZONE column, NOT NULL constraint. |
| ORDER_MODE | VARCHAR2(8) | null | | CHECK constraint. |
| CUSTOMER_ID | NUMBER(6, 0) | not null | | |
| ORDER_STATUS | NUMBER(2, 0) | null | | 0: Not fully entered, 1: Entered, 2: Canceled - bad credit, - |
| ORDER_TOTAL | NUMBER(8, 2) | null | | CHECK constraint. |
| SALES_REP_ID | NUMBER(6, 0) | null | | References hr.employees.employee_id. |
| PROMOTION_ID | NUMBER(6, 0) | null | | Sales promotion ID. Used in SH schema |